/*
 Navicat Premium Data Transfer

 Source Server         : .
 Source Server Type    : MariaDB
 Source Server Version : 100313
 Source Host           : localhost:3306
 Source Schema         : aaa

 Target Server Type    : MariaDB
 Target Server Version : 100313
 File Encoding         : 65001

 Date: 08/10/2021 10:32:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` varchar(24) NOT NULL,
  `vloger_id` varchar(24) NOT NULL COMMENT '评论的视频是哪个作者（vloger）的关联id',
  `father_comment_id` varchar(24) NOT NULL COMMENT '如果是回复留言，则本条为子留言，需要关联查询',
  `vlog_id` varchar(24) NOT NULL COMMENT '回复的那个视频id',
  `comment_user_id` varchar(24) NOT NULL COMMENT '发布留言的用户id',
  `content` varchar(128) NOT NULL COMMENT '留言内容',
  `like_counts` int(20) NOT NULL COMMENT '留言的点赞总数',
  `create_time` datetime NOT NULL COMMENT '留言时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES ('211004K23D53K4ZC', '1001', '0', '2110048SH1BRRP94', '1001', 'JS妥妥的，java联动也ok~~😊', 0, '2021-10-04 23:55:34');
INSERT INTO `comment` VALUES ('21100580D993C3XP', '1001', '211004K23D53K4ZC', '2110048SH1BRRP94', '211005800N0W837C', '没毛病', 0, '2021-10-05 11:13:59');
INSERT INTO `comment` VALUES ('21100580H3HS24PH', '2110057Y6PN9WMK4', '0', '2110057Z0WAZWBC0', '211005800N0W837C', '看着不错，在哪里吃啊？', 0, '2021-10-05 11:14:17');
INSERT INTO `comment` VALUES ('21100581H7NGZRD4', '2110057Y6PN9WMK4', '0', '2110057ZG1394940', '1001', '啥玩意？？', 0, '2021-10-05 11:17:18');
INSERT INTO `comment` VALUES ('21100581KPRZTSCH', '2110057Y6PN9WMK4', '0', '2110057ZG1394940', '1001', '水猴子？🐒？？？', 0, '2021-10-05 11:17:27');
INSERT INTO `comment` VALUES ('2110058FDDMSC9D4', '2110058D0KPZSCH0', '0', '2110058DBZ4RSWZC', '2110058DPP1ZPKKP', '我家龙哥', 0, '2021-10-05 11:56:02');
INSERT INTO `comment` VALUES ('2110058FH5DK9XWH', '2110058BX246X39P', '0', '2110058CKB0R4S5P', '2110058DPP1ZPKKP', '伙食不错', 0, '2021-10-05 11:56:19');
INSERT INTO `comment` VALUES ('2110058GKASX26A8', '1001', '0', '2110048SH1BRRP94', '2110058FN9GYCFNC', '没毛病', 0, '2021-10-05 11:59:27');
INSERT INTO `comment` VALUES ('2110058GPX5130H0', '2110057Y6PN9WMK4', '0', '2110057Z0WAZWBC0', '2110058FN9GYCFNC', '同问', 0, '2021-10-05 11:59:50');
INSERT INTO `comment` VALUES ('2110058K2M429DS8', '2110058BX246X39P', '0', '2110058CKB0R4S5P', '2110058HSCZ3MAY8', '是啊', 0, '2021-10-05 12:03:53');
INSERT INTO `comment` VALUES ('21100594P0RW38PH', '21100593CR144MK4', '0', '21100594K819846W', '21100593CR144MK4', '吃吃', 0, '2021-10-05 12:50:47');
INSERT INTO `comment` VALUES ('21100594RWK7B4DP', '211005929C8GTNTC', '0', '2110059373F4ADWH', '21100593CR144MK4', '啥？😊', 0, '2021-10-05 12:50:59');
INSERT INTO `comment` VALUES ('2110059895RFFC6W', '21100593CR144MK4', '0', '211005956F0BN7R4', '1001', '拍的不错', 0, '2021-10-05 13:01:38');
INSERT INTO `comment` VALUES ('2110059A6585N4DP', '21100598TZ9XG6RP', '0', '21100599X82DARAW', '21100598TZ9XG6RP', '笑尿了，哈哈哈哈😄2333', 0, '2021-10-05 13:07:19');
INSERT INTO `comment` VALUES ('2110059FC01130H0', '21100598TZ9XG6RP', '0', '21100599X82DARAW', '2110057Y6PN9WMK4', '笑死我了，这视频得火。🤦🏻', 0, '2021-10-05 13:19:57');
INSERT INTO `comment` VALUES ('2110059FFYB03DYW', '21100598TZ9XG6RP', '0', '21100599C6HCGXAW', '2110057Y6PN9WMK4', '真漂亮，在哪？', 0, '2021-10-05 13:20:16');
INSERT INTO `comment` VALUES ('2110059FHYC6P7F8', '211005967WASBB9P', '0', '21100597NPC09FCH', '2110057Y6PN9WMK4', '好吃吗？', 0, '2021-10-05 13:20:28');
INSERT INTO `comment` VALUES ('2110059FMWPA90PH', '211005967WASBB9P', '0', '21100597F3ABW0ZC', '2110057Y6PN9WMK4', '美女真漂亮', 0, '2021-10-05 13:20:41');
INSERT INTO `comment` VALUES ('2110059FPPNMRYFW', '21100593CR144MK4', '0', '21100594K819846W', '2110057Y6PN9WMK4', '看着不错呀', 0, '2021-10-05 13:20:53');
INSERT INTO `comment` VALUES ('2110059FSXR4DSK4', '211005929C8GTNTC', '0', '2110059373F4ADWH', '2110057Y6PN9WMK4', '秋天？', 0, '2021-10-05 13:21:07');
INSERT INTO `comment` VALUES ('2110059FWRC89ZF8', '211005929C8GTNTC', '0', '211005931KAH325P', '2110057Y6PN9WMK4', '就知道吃', 0, '2021-10-05 13:21:19');
INSERT INTO `comment` VALUES ('2110059FZ07KG1GC', '2110058FN9GYCFNC', '0', '2110058GDGCAZDYW', '2110057Y6PN9WMK4', '杰森斯坦森！！！', 0, '2021-10-05 13:21:33');
INSERT INTO `comment` VALUES ('2110059G0SFC1KP0', '2110058BX246X39P', '0', '2110058CKB0R4S5P', '2110057Y6PN9WMK4', '挺好', 0, '2021-10-05 13:21:45');
INSERT INTO `comment` VALUES ('2110059G35XCXTHH', '2110057Y6PN9WMK4', '0', '2110057ZG1394940', '2110057Y6PN9WMK4', '猴子游泳了？', 0, '2021-10-05 13:22:00');
INSERT INTO `comment` VALUES ('2110059G4T1H2MCH', '1001', '0', '2110048SH1BRRP94', '2110057Y6PN9WMK4', '哈哈哈', 0, '2021-10-05 13:22:11');
INSERT INTO `comment` VALUES ('2110059H55W3RBTC', '21100598TZ9XG6RP', '0', '21100599X82DARAW', '211005800N0W837C', '噗。。。我正好在喝水。。。🤣', 0, '2021-10-05 13:25:13');
INSERT INTO `comment` VALUES ('2110059HA0D25C4H', '21100598TZ9XG6RP', '0', '21100599C6HCGXAW', '211005800N0W837C', '可以去冲浪', 0, '2021-10-05 13:25:44');
INSERT INTO `comment` VALUES ('2110059HM4AH07TC', '2110058FN9GYCFNC', '0', '2110058GDGCAZDYW', '211005800N0W837C', '速度与激情10？？', 0, '2021-10-05 13:26:37');
INSERT INTO `comment` VALUES ('2110059HT6CPNA14', '2110058BX246X39P', '0', '2110058CKB0R4S5P', '211005800N0W837C', '吃饭', 0, '2021-10-05 13:27:09');
INSERT INTO `comment` VALUES ('2110059HXBBMR0BC', '1001', '0', '2110048SH1BRRP94', '211005800N0W837C', '我来了老铁', 0, '2021-10-05 13:27:23');
INSERT INTO `comment` VALUES ('2110059K03M55SY8', '1001', '0', '2110048SF3RC8W4H', '211005800N0W837C', '都行，没毛病', 0, '2021-10-05 13:27:41');
INSERT INTO `comment` VALUES ('2110059K3MKF8TF8', '1001', '0', '2110048SBFZ8N25P', '211005800N0W837C', '运维要给力啊', 0, '2021-10-05 13:28:03');
INSERT INTO `comment` VALUES ('2110059KH99T6N2W', '1001', '0', '2110048S95SXG2W0', '211005800N0W837C', '内卷啊。。阿西吧', 0, '2021-10-05 13:29:25');
INSERT INTO `comment` VALUES ('2110059KKWDRFG54', '1001', '0', '2110048S5RK2BB9P', '211005800N0W837C', '卷中卷', 0, '2021-10-05 13:29:35');
INSERT INTO `comment` VALUES ('2110059KN5DFRFRP', '1001', '0', '2110048RXXDD2F5P', '211005800N0W837C', '来了来了', 0, '2021-10-05 13:29:43');
INSERT INTO `comment` VALUES ('2110059KP20G3GHH', '1001', '0', '2110048RS1AK5N0H', '211005800N0W837C', '2333', 0, '2021-10-05 13:29:49');
INSERT INTO `comment` VALUES ('2110059KS8CMBG7C', '1001', '0', '2110048RMXYN8KYW', '211005800N0W837C', '有必要的，面试经常被问。。', 0, '2021-10-05 13:30:03');
INSERT INTO `comment` VALUES ('2110059M369WK8H0', '1001', '0', '2110048RAYSPYG54', '211005800N0W837C', '万金油~~', 0, '2021-10-05 13:31:01');
INSERT INTO `comment` VALUES ('2110059M4TDZS3C0', '1001', '0', '2110048R6R5WW0M8', '211005800N0W837C', '哦了', 0, '2021-10-05 13:31:11');
INSERT INTO `comment` VALUES ('2110059M6KCR3DKP', '1001', '0', '2110048PYTNFGCZC', '211005800N0W837C', 'Hello', 0, '2021-10-05 13:31:23');
INSERT INTO `comment` VALUES ('2110059M9GWXGGXP', '1001', '0', '2109307DX5GFABXP', '211005800N0W837C', '哈哈哈', 0, '2021-10-05 13:31:42');
INSERT INTO `comment` VALUES ('211005A4CA0W9S80', '21100598TZ9XG6RP', '0', '21100599X82DARAW', '2110058BX246X39P', '哎呦我去。。。笑死我了😊', 0, '2021-10-05 14:14:02');
INSERT INTO `comment` VALUES ('211005A4FBF8WKKP', '21100598TZ9XG6RP', '0', '21100599C6HCGXAW', '2110058BX246X39P', '是漂亮', 0, '2021-10-05 14:14:15');
INSERT INTO `comment` VALUES ('211005A56HMFGHX4', '211005967WASBB9P', '2110059FHYC6P7F8', '21100597NPC09FCH', '2110058BX246X39P', '还行吧', 0, '2021-10-05 14:16:25');
INSERT INTO `comment` VALUES ('211005A583B6YAK4', '211005967WASBB9P', '0', '21100597F3ABW0ZC', '2110058BX246X39P', '哈哈哈', 0, '2021-10-05 14:16:35');
INSERT INTO `comment` VALUES ('211005A5AAYC7BMW', '211005929C8GTNTC', '0', '211005931KAH325P', '2110058BX246X39P', '还可以吧', 0, '2021-10-05 14:16:49');
INSERT INTO `comment` VALUES ('211005A5C9H5B91P', '2110058FN9GYCFNC', '0', '2110058GDGCAZDYW', '2110058BX246X39P', '必须爱杰森啊', 0, '2021-10-05 14:17:02');
INSERT INTO `comment` VALUES ('211005A5XG0F00M8', '1001', '0', '2110048SF3RC8W4H', '2110058BX246X39P', '666老铁', 0, '2021-10-05 14:18:27');
INSERT INTO `comment` VALUES ('211005A5YHCD9PM8', '1001', '2110059K3MKF8TF8', '2110048SBFZ8N25P', '2110058BX246X39P', '是的', 0, '2021-10-05 14:18:33');
INSERT INTO `comment` VALUES ('211005A5ZZZRAX8H', '1001', '0', '2110048S95SXG2W0', '2110058BX246X39P', '必须的', 0, '2021-10-05 14:18:42');
INSERT INTO `comment` VALUES ('211005A60XWMTW28', '1001', '0', '2110048S5RK2BB9P', '2110058BX246X39P', '哈哈哈', 0, '2021-10-05 14:18:48');
INSERT INTO `comment` VALUES ('211005A622ZAC9D4', '1001', '0', '2110048RXXDD2F5P', '2110058BX246X39P', '嗯是的', 0, '2021-10-05 14:18:56');
INSERT INTO `comment` VALUES ('211005A63MCH0PX4', '1001', '0', '2110048RS1AK5N0H', '2110058BX246X39P', '看过了', 0, '2021-10-05 14:19:06');
INSERT INTO `comment` VALUES ('211005A6H0MS223C', '1001', '0', '2110048RMXYN8KYW', '2110058BX246X39P', '学学更健康', 0, '2021-10-05 14:20:26');
INSERT INTO `comment` VALUES ('211005A6NM329214', '1001', '0', '2110048R6R5WW0M8', '2110058BX246X39P', '还行', 0, '2021-10-05 14:20:49');
INSERT INTO `comment` VALUES ('211005A6PSKSYMCH', '1001', '0', '2110048PYTNFGCZC', '2110058BX246X39P', '奈斯！！', 0, '2021-10-05 14:20:56');
INSERT INTO `comment` VALUES ('211005ADA5K76DWH', '2110058BX246X39P', '0', '2110058CKB0R4S5P', '2110058BX246X39P', '咋样？眼馋不', 0, '2021-10-05 14:40:49');
INSERT INTO `comment` VALUES ('211005AF39C52XYW', '21100598TZ9XG6RP', '0', '21100599X82DARAW', '2110058D0KPZSCH0', '哈哈哈太逗比了😅', 0, '2021-10-05 14:43:05');
INSERT INTO `comment` VALUES ('211005AF80Y3C000', '21100593CR144MK4', '2110059895RFFC6W', '211005956F0BN7R4', '2110058D0KPZSCH0', '相当可以', 0, '2021-10-05 14:43:35');
INSERT INTO `comment` VALUES ('211005AFH0FDSFFW', '1001', '0', '2110048PYTNFGCZC', '2110058D0KPZSCH0', '之前看过，还不错，老师会在群里交流', 0, '2021-10-05 14:44:27');
INSERT INTO `comment` VALUES ('211005AFM15WRRYW', '1001', '0', '2110048R6R5WW0M8', '2110058D0KPZSCH0', '666😊', 0, '2021-10-05 14:44:40');
COMMIT;

-- ----------------------------
-- Table structure for fans
-- ----------------------------
DROP TABLE IF EXISTS `fans`;
CREATE TABLE `fans` (
  `id` varchar(24) NOT NULL,
  `vloger_id` varchar(24) NOT NULL COMMENT '作家用户id',
  `fan_id` varchar(24) NOT NULL COMMENT '粉丝用户id',
  `is_fan_friend_of_mine` int(1) NOT NULL COMMENT '粉丝是否是vloger的朋友，如果成为朋友，则本表的双方此字段都需要设置为1，如果有一人取关，则两边都需要设置为0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `writer_id` (`vloger_id`,`fan_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='粉丝表\n\n';

-- ----------------------------
-- Records of fans
-- ----------------------------
BEGIN;
INSERT INTO `fans` VALUES ('2110057Y9ADR26A8', '1001', '2110057Y6PN9WMK4', 1);
INSERT INTO `fans` VALUES ('2110057YB9CM344H', '211003H4SG5Y1ZF8', '2110057Y6PN9WMK4', 0);
INSERT INTO `fans` VALUES ('21100580ADHWKCDP', '2110057Y6PN9WMK4', '211005800N0W837C', 0);
INSERT INTO `fans` VALUES ('21100580AY07ZFY8', '1001', '211005800N0W837C', 1);
INSERT INTO `fans` VALUES ('2110058171C7F2RP', '211005800N0W837C', '1001', 1);
INSERT INTO `fans` VALUES ('21100581BZ779AW0', '2110057Y6PN9WMK4', '1001', 1);
INSERT INTO `fans` VALUES ('2110058C23BKGC00', '2110057Y6PN9WMK4', '2110058BX246X39P', 1);
INSERT INTO `fans` VALUES ('2110058C2F52KAFW', '1001', '2110058BX246X39P', 0);
INSERT INTO `fans` VALUES ('2110058DD1GGRZF8', '2110058BX246X39P', '2110058D0KPZSCH0', 0);
INSERT INTO `fans` VALUES ('2110058DD9WMRKAW', '2110057Y6PN9WMK4', '2110058D0KPZSCH0', 0);
INSERT INTO `fans` VALUES ('2110058DFRZGG25P', '1001', '2110058D0KPZSCH0', 0);
INSERT INTO `fans` VALUES ('2110058F9H8K2S14', '2110058D0KPZSCH0', '2110058DPP1ZPKKP', 0);
INSERT INTO `fans` VALUES ('2110058FA2Y7YF5P', '2110058BX246X39P', '2110058DPP1ZPKKP', 0);
INSERT INTO `fans` VALUES ('2110058FA86T1WH0', '2110057Y6PN9WMK4', '2110058DPP1ZPKKP', 0);
INSERT INTO `fans` VALUES ('2110058FAMAZM1S8', '1001', '2110058DPP1ZPKKP', 0);
INSERT INTO `fans` VALUES ('2110058GGB535K1P', '2110058D0KPZSCH0', '2110058FN9GYCFNC', 0);
INSERT INTO `fans` VALUES ('2110058GGHNAN1GC', '2110058BX246X39P', '2110058FN9GYCFNC', 1);
INSERT INTO `fans` VALUES ('2110058GH0NSZ3F8', '2110057Y6PN9WMK4', '2110058FN9GYCFNC', 0);
INSERT INTO `fans` VALUES ('2110058GH99NK4ZC', '1001', '2110058FN9GYCFNC', 1);
INSERT INTO `fans` VALUES ('2110058M200GKA5P', '2110058FN9GYCFNC', '1001', 1);
INSERT INTO `fans` VALUES ('211005932XF95YW0', '2110058FN9GYCFNC', '211005929C8GTNTC', 0);
INSERT INTO `fans` VALUES ('2110059339D1PGMW', '2110058D0KPZSCH0', '211005929C8GTNTC', 0);
INSERT INTO `fans` VALUES ('21100593496A8Y3C', '1001', '211005929C8GTNTC', 1);
INSERT INTO `fans` VALUES ('211005941R2R577C', '211005929C8GTNTC', '21100593CR144MK4', 0);
INSERT INTO `fans` VALUES ('2110059431ARNSRP', '1001', '21100593CR144MK4', 1);
INSERT INTO `fans` VALUES ('21100597H22W1N0H', '1001', '211005967WASBB9P', 1);
INSERT INTO `fans` VALUES ('21100597SX02ZB9P', '211005929C8GTNTC', '1001', 1);
INSERT INTO `fans` VALUES ('2110059G1KRDX7HH', '2110058BX246X39P', '2110057Y6PN9WMK4', 1);
INSERT INTO `fans` VALUES ('2110059HN0NPHNHH', '2110058D0KPZSCH0', '211005800N0W837C', 0);
INSERT INTO `fans` VALUES ('211005A5787HKN0H', '211005967WASBB9P', '2110058BX246X39P', 0);
INSERT INTO `fans` VALUES ('211005A5ASRR725P', '2110058FN9GYCFNC', '2110058BX246X39P', 1);
INSERT INTO `fans` VALUES ('211005AF10KRPNHH', '21100598TZ9XG6RP', '2110058D0KPZSCH0', 0);
INSERT INTO `fans` VALUES ('211006GN2H4DW84H', '211005967WASBB9P', '1001', 1);
INSERT INTO `fans` VALUES ('2110077K60T3CZC0', '21100593CR144MK4', '1001', 1);
COMMIT;

-- ----------------------------
-- Table structure for my_liked_vlog
-- ----------------------------
DROP TABLE IF EXISTS `my_liked_vlog`;
CREATE TABLE `my_liked_vlog` (
  `id` varchar(24) NOT NULL,
  `user_id` varchar(24) NOT NULL COMMENT '用户id',
  `vlog_id` varchar(24) NOT NULL COMMENT '喜欢的短视频id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `writer_id` (`user_id`,`vlog_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点赞短视频关联表\n';

-- ----------------------------
-- Records of my_liked_vlog
-- ----------------------------
BEGIN;
INSERT INTO `my_liked_vlog` VALUES ('211004HM4NYMM9YW', '1001', '2110048SH1BRRP94');
INSERT INTO `my_liked_vlog` VALUES ('21100582BHRD31WH', '1001', '2110057ZG1394940');
INSERT INTO `my_liked_vlog` VALUES ('211005ASYXSKZ3TC', '1001', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('211005AGFBMMFZXP', '1001', '2110058GDGCAZDYW');
INSERT INTO `my_liked_vlog` VALUES ('211005AGF6T1251P', '1001', '211005931KAH325P');
INSERT INTO `my_liked_vlog` VALUES ('211005AGDXYT0ARP', '1001', '2110059373F4ADWH');
INSERT INTO `my_liked_vlog` VALUES ('211005AGDRYHM04H', '1001', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('211005AGDKMN90BC', '1001', '211005956F0BN7R4');
INSERT INTO `my_liked_vlog` VALUES ('211005987B5Y9CDP', '1001', '21100597F3ABW0ZC');
INSERT INTO `my_liked_vlog` VALUES ('211005987KZS2N2W', '1001', '21100597NPC09FCH');
INSERT INTO `my_liked_vlog` VALUES ('2110070WZ0DG6B7C', '1001', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('211005AGCC0FBRS8', '1001', '21100599X82DARAW');
INSERT INTO `my_liked_vlog` VALUES ('2110057YBF7X9A5P', '2110057Y6PN9WMK4', '211003HC19CASM3C');
INSERT INTO `my_liked_vlog` VALUES ('2110057YFZ7G5GR4', '2110057Y6PN9WMK4', '2110048PYTNFGCZC');
INSERT INTO `my_liked_vlog` VALUES ('2110059G217MZXP0', '2110057Y6PN9WMK4', '2110057ZG1394940');
INSERT INTO `my_liked_vlog` VALUES ('2110059G1B0KC8DP', '2110057Y6PN9WMK4', '2110058CKB0R4S5P');
INSERT INTO `my_liked_vlog` VALUES ('2110059FZS015YW0', '2110057Y6PN9WMK4', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('2110059FZDH3R1AW', '2110057Y6PN9WMK4', '2110058GDGCAZDYW');
INSERT INTO `my_liked_vlog` VALUES ('2110059FRB334RGC', '2110057Y6PN9WMK4', '2110059373F4ADWH');
INSERT INTO `my_liked_vlog` VALUES ('2110059FR4FF3D8H', '2110057Y6PN9WMK4', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('2110059FNCBRMXYW', '2110057Y6PN9WMK4', '211005956F0BN7R4');
INSERT INTO `my_liked_vlog` VALUES ('2110059FKZ2RH280', '2110057Y6PN9WMK4', '21100597F3ABW0ZC');
INSERT INTO `my_liked_vlog` VALUES ('2110059FGRZNF800', '2110057Y6PN9WMK4', '21100597NPC09FCH');
INSERT INTO `my_liked_vlog` VALUES ('2110059FDK79NC94', '2110057Y6PN9WMK4', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('2110059F78SM90PH', '2110057Y6PN9WMK4', '21100599X82DARAW');
INSERT INTO `my_liked_vlog` VALUES ('2110059M91DSYMCH', '211005800N0W837C', '2109307DX5GFABXP');
INSERT INTO `my_liked_vlog` VALUES ('2110059M8MB5ZNF8', '211005800N0W837C', '211001BKH355BGHH');
INSERT INTO `my_liked_vlog` VALUES ('2110059M3NKFYGTC', '211005800N0W837C', '2110048R6R5WW0M8');
INSERT INTO `my_liked_vlog` VALUES ('2110059M14HWGB0H', '211005800N0W837C', '2110048RAYSPYG54');
INSERT INTO `my_liked_vlog` VALUES ('2110059KPD61Z91P', '211005800N0W837C', '2110048RMXYN8KYW');
INSERT INTO `my_liked_vlog` VALUES ('2110059KNDG262CH', '211005800N0W837C', '2110048RS1AK5N0H');
INSERT INTO `my_liked_vlog` VALUES ('2110059KM74MY800', '211005800N0W837C', '2110048RXXDD2F5P');
INSERT INTO `my_liked_vlog` VALUES ('2110059KHR35KSK4', '211005800N0W837C', '2110048S5RK2BB9P');
INSERT INTO `my_liked_vlog` VALUES ('2110059K4BK2GF80', '211005800N0W837C', '2110048S95SXG2W0');
INSERT INTO `my_liked_vlog` VALUES ('2110059K0MBB0094', '211005800N0W837C', '2110048SBFZ8N25P');
INSERT INTO `my_liked_vlog` VALUES ('2110059HYDNRMA80', '211005800N0W837C', '2110048SF3RC8W4H');
INSERT INTO `my_liked_vlog` VALUES ('2110059HWGHFFYK4', '211005800N0W837C', '2110048SH1BRRP94');
INSERT INTO `my_liked_vlog` VALUES ('2110059HWAMNMFW0', '211005800N0W837C', '2110057Z0WAZWBC0');
INSERT INTO `my_liked_vlog` VALUES ('2110059HTY9A8FA8', '211005800N0W837C', '2110057ZG1394940');
INSERT INTO `my_liked_vlog` VALUES ('2110059HN85Y40ZC', '211005800N0W837C', '2110058CKB0R4S5P');
INSERT INTO `my_liked_vlog` VALUES ('2110059HMS2473TC', '211005800N0W837C', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('2110059HMFF037C0', '211005800N0W837C', '2110058GDGCAZDYW');
INSERT INTO `my_liked_vlog` VALUES ('2110059HHWG9PPX4', '211005800N0W837C', '211005931KAH325P');
INSERT INTO `my_liked_vlog` VALUES ('2110059HH85S09S8', '211005800N0W837C', '2110059373F4ADWH');
INSERT INTO `my_liked_vlog` VALUES ('2110059HGY5WTTC0', '211005800N0W837C', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('2110059HFX75B7R4', '211005800N0W837C', '211005956F0BN7R4');
INSERT INTO `my_liked_vlog` VALUES ('2110059HFN3AK028', '211005800N0W837C', '21100597F3ABW0ZC');
INSERT INTO `my_liked_vlog` VALUES ('2110059HF8X7C7TC', '211005800N0W837C', '21100597NPC09FCH');
INSERT INTO `my_liked_vlog` VALUES ('2110059H8GTNBDKP', '211005800N0W837C', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('2110059H17A79494', '211005800N0W837C', '21100599X82DARAW');
INSERT INTO `my_liked_vlog` VALUES ('211005A6R4MGZXAW', '2110058BX246X39P', '211003HC19CASM3C');
INSERT INTO `my_liked_vlog` VALUES ('211005A6P1T35968', '2110058BX246X39P', '2110048PYTNFGCZC');
INSERT INTO `my_liked_vlog` VALUES ('211005A6MXYBFNR4', '2110058BX246X39P', '2110048R6R5WW0M8');
INSERT INTO `my_liked_vlog` VALUES ('211005A6K9M1MXYW', '2110058BX246X39P', '2110048RAYSPYG54');
INSERT INTO `my_liked_vlog` VALUES ('211005A645DH52A8', '2110058BX246X39P', '2110048RMXYN8KYW');
INSERT INTO `my_liked_vlog` VALUES ('211005A62HMZ3WPH', '2110058BX246X39P', '2110048RS1AK5N0H');
INSERT INTO `my_liked_vlog` VALUES ('211005A619A3D8H0', '2110058BX246X39P', '2110048RXXDD2F5P');
INSERT INTO `my_liked_vlog` VALUES ('211005A60BTH0NHH', '2110058BX246X39P', '2110048S5RK2BB9P');
INSERT INTO `my_liked_vlog` VALUES ('211005A5Z51D5N0H', '2110058BX246X39P', '2110048S95SXG2W0');
INSERT INTO `my_liked_vlog` VALUES ('211005A5XYPX2WM8', '2110058BX246X39P', '2110048SBFZ8N25P');
INSERT INTO `my_liked_vlog` VALUES ('211005A5W3PFMW94', '2110058BX246X39P', '2110048SF3RC8W4H');
INSERT INTO `my_liked_vlog` VALUES ('211005A5TRH37K68', '2110058BX246X39P', '2110048SH1BRRP94');
INSERT INTO `my_liked_vlog` VALUES ('211005A5TFMTZC94', '2110058BX246X39P', '2110057Z0WAZWBC0');
INSERT INTO `my_liked_vlog` VALUES ('211005A5T67MZPDP', '2110058BX246X39P', '2110057ZG1394940');
INSERT INTO `my_liked_vlog` VALUES ('211005A5RPANXZTC', '2110058BX246X39P', '2110058CKB0R4S5P');
INSERT INTO `my_liked_vlog` VALUES ('211005A5CRWC1G2W', '2110058BX246X39P', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('211005A5ARHAAWZC', '2110058BX246X39P', '2110058GDGCAZDYW');
INSERT INTO `my_liked_vlog` VALUES ('211005A5972HDFRP', '2110058BX246X39P', '211005931KAH325P');
INSERT INTO `my_liked_vlog` VALUES ('211005A591SX6WZC', '2110058BX246X39P', '2110059373F4ADWH');
INSERT INTO `my_liked_vlog` VALUES ('211005A58SD99T7C', '2110058BX246X39P', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('211005A58GPCWW4H', '2110058BX246X39P', '211005956F0BN7R4');
INSERT INTO `my_liked_vlog` VALUES ('211005A57BM7N6CH', '2110058BX246X39P', '21100597F3ABW0ZC');
INSERT INTO `my_liked_vlog` VALUES ('211005A54F5X4S5P', '2110058BX246X39P', '21100597NPC09FCH');
INSERT INTO `my_liked_vlog` VALUES ('211005A4DD8433F8', '2110058BX246X39P', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('211005AFD2KGW3HH', '2110058D0KPZSCH0', '211003HC19CASM3C');
INSERT INTO `my_liked_vlog` VALUES ('211005AFCWYBX9GC', '2110058D0KPZSCH0', '2110048PYTNFGCZC');
INSERT INTO `my_liked_vlog` VALUES ('211005AFCNG93RD4', '2110058D0KPZSCH0', '2110048R6R5WW0M8');
INSERT INTO `my_liked_vlog` VALUES ('211005AFCDZYYFFW', '2110058D0KPZSCH0', '2110048RAYSPYG54');
INSERT INTO `my_liked_vlog` VALUES ('211005AFC93PC0ZC', '2110058D0KPZSCH0', '2110048RMXYN8KYW');
INSERT INTO `my_liked_vlog` VALUES ('211005AFC4RZY140', '2110058D0KPZSCH0', '2110048RS1AK5N0H');
INSERT INTO `my_liked_vlog` VALUES ('211005AFC03PHNHH', '2110058D0KPZSCH0', '2110048RXXDD2F5P');
INSERT INTO `my_liked_vlog` VALUES ('211005AFBPXYD4ZC', '2110058D0KPZSCH0', '2110048S5RK2BB9P');
INSERT INTO `my_liked_vlog` VALUES ('211005AFBD9XPTF8', '2110058D0KPZSCH0', '2110048S95SXG2W0');
INSERT INTO `my_liked_vlog` VALUES ('211005AFB7K8TM5P', '2110058D0KPZSCH0', '2110048SBFZ8N25P');
INSERT INTO `my_liked_vlog` VALUES ('211005AFB2K1PGMW', '2110058D0KPZSCH0', '2110048SF3RC8W4H');
INSERT INTO `my_liked_vlog` VALUES ('211005AFAKG74XD4', '2110058D0KPZSCH0', '2110048SH1BRRP94');
INSERT INTO `my_liked_vlog` VALUES ('211005AFABWZ2W00', '2110058D0KPZSCH0', '2110057Z0WAZWBC0');
INSERT INTO `my_liked_vlog` VALUES ('211005AFA6ANKBF8', '2110058D0KPZSCH0', '2110057ZG1394940');
INSERT INTO `my_liked_vlog` VALUES ('211005AFA0GX8K8H', '2110058D0KPZSCH0', '2110058CKB0R4S5P');
INSERT INTO `my_liked_vlog` VALUES ('211005ADZTH87GHH', '2110058D0KPZSCH0', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('211005AF9NSK3KGC', '2110058D0KPZSCH0', '2110058GDGCAZDYW');
INSERT INTO `my_liked_vlog` VALUES ('211005AF9F646H4H', '2110058D0KPZSCH0', '211005931KAH325P');
INSERT INTO `my_liked_vlog` VALUES ('211005AF99S68ZC0', '2110058D0KPZSCH0', '2110059373F4ADWH');
INSERT INTO `my_liked_vlog` VALUES ('211005AF93ZS6S14', '2110058D0KPZSCH0', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('211005AF618CYXKP', '2110058D0KPZSCH0', '211005956F0BN7R4');
INSERT INTO `my_liked_vlog` VALUES ('211005AF5TC28568', '2110058D0KPZSCH0', '21100597F3ABW0ZC');
INSERT INTO `my_liked_vlog` VALUES ('211005AF5M6D1KAW', '2110058D0KPZSCH0', '21100597NPC09FCH');
INSERT INTO `my_liked_vlog` VALUES ('211005AF5DW02BXP', '2110058D0KPZSCH0', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('211005AF12ZYBB9P', '2110058D0KPZSCH0', '21100599X82DARAW');
INSERT INTO `my_liked_vlog` VALUES ('2110058FF2ATHK8H', '2110058DPP1ZPKKP', '2110058DBZ4RSWZC');
INSERT INTO `my_liked_vlog` VALUES ('21100594N2SB046W', '21100593CR144MK4', '21100594K819846W');
INSERT INTO `my_liked_vlog` VALUES ('21100599DG25CG0H', '21100598TZ9XG6RP', '21100599C6HCGXAW');
INSERT INTO `my_liked_vlog` VALUES ('2110059A3CGXN1WH', '21100598TZ9XG6RP', '21100599X82DARAW');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` varchar(24) NOT NULL,
  `mobile` varchar(32) NOT NULL COMMENT '手机号',
  `nickname` varchar(16) NOT NULL COMMENT '昵称，媒体号',
  `imooc_num` varchar(16) NOT NULL COMMENT '慕课号，类似头条号，抖音号，公众号，唯一标识，需要限制修改次数，比如终生1次，每年1次，每半年1次等，可以用于付费修改。',
  `face` varchar(128) NOT NULL COMMENT '头像',
  `sex` int(11) NOT NULL COMMENT '性别 1:男  0:女  2:保密',
  `birthday` date NOT NULL COMMENT '生日',
  `country` varchar(32) DEFAULT NULL COMMENT '国家',
  `province` varchar(32) DEFAULT NULL COMMENT '省份',
  `city` varchar(32) DEFAULT NULL COMMENT '城市',
  `district` varchar(32) DEFAULT NULL COMMENT '区县',
  `description` varchar(100) NOT NULL COMMENT '简介',
  `bg_img` varchar(255) DEFAULT NULL COMMENT '个人介绍的背景图',
  `can_imooc_num_be_updated` int(1) NOT NULL COMMENT '慕课号能否被修改，1：默认，可以修改；0，无法修改',
  `created_time` datetime NOT NULL COMMENT '创建时间 创建时间',
  `updated_time` datetime NOT NULL COMMENT '更新时间 更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `mobile` (`mobile`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('1001', '13912345678', '风间影月', 'imooc-test', 'http://39.105.38.113:9000/abc/1001/1632969079.jpg', 2, '2021-08-08', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/1001/1632969089.jpg', 1, '2021-09-29 23:44:51', '2021-09-29 23:44:51');
INSERT INTO `users` VALUES ('211003H4SG5Y1ZF8', '13961888888', '小城大牛', 'daniu123', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 2, '1900-01-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', NULL, 1, '2021-10-03 22:39:32', '2021-10-03 22:39:32');
INSERT INTO `users` VALUES ('2110057Y6PN9WMK4', '13961111111', '顾晓梦', 'guumee', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '1900-01-01', '中国', '', '', '', '哈哈哈哈 有意思！！！', NULL, 0, '2021-10-05 11:07:16', '2021-10-05 11:07:16');
INSERT INTO `users` VALUES ('211005800N0W837C', '13912312311', '樱木花道', 'sakura', 'http://39.105.38.113:9000/abc/211005800N0W837C/photo_001.jpg', 1, '1970-01-01', '中国', '黑龙江省', '佳木斯市', '', '我是灌篮高手！啊呀呀呀呀呀呀呀', 'http://39.105.38.113:9000/abc/211005800N0W837C/1633404391.jpg', 0, '2021-10-05 11:12:37', '2021-10-05 11:12:37');
INSERT INTO `users` VALUES ('2110058BX246X39P', '13900010001', '王多鱼', '00010001', 'http://39.105.38.113:9000/abc/2110058BX246X39P/1633405706.jpg', 1, '1900-01-01', '中国', '上海市', '徐汇区', '', '233333，xswl', 'http://39.105.38.113:9000/abc/2110058BX246X39P/1633405718.jpg', 0, '2021-10-05 11:48:16', '2021-10-05 11:48:16');
INSERT INTO `users` VALUES ('2110058D0KPZSCH0', '13961610002', '朱一龙', 'Longlong', 'http://39.105.38.113:9000/abc/2110058D0KPZSCH0/1633405958.jpg', 1, '1900-01-01', '中国', '天津市', '和平区', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058D0KPZSCH0/1633405944.jpg', 0, '2021-10-05 11:51:39', '2021-10-05 11:51:39');
INSERT INTO `users` VALUES ('2110058DPP1ZPKKP', '13966660003', '夏侯惇', '鼠辈吃我一记', 'http://39.105.38.113:9000/abc/2110058DPP1ZPKKP/1633406052.jpg', 1, '1984-03-01', '中国', '浙江省', '温州市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058DPP1ZPKKP/1633406083.jpg', 0, '2021-10-05 11:53:48', '2021-10-05 11:53:48');
INSERT INTO `users` VALUES ('2110058FN9GYCFNC', '13800040004', '越野小天', 'Jeep123', 'http://39.105.38.113:9000/abc/2110058FN9GYCFNC/1633406219.jpg', 0, '1970-01-27', '中国', '河北省', '保定市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058FN9GYCFNC/1633406246.jpg', 0, '2021-10-05 11:56:40', '2021-10-05 11:56:40');
INSERT INTO `users` VALUES ('2110058HSCZ3MAY8', '13800050005', '用户：13******005', '用户：13******005', 'http://39.105.38.113:9000/abc/2110058HSCZ3MAY8/1633406595.jpg', 2, '1900-01-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058HSCZ3MAY8/1633406607.jpg', 1, '2021-10-05 12:03:00', '2021-10-05 12:03:00');
INSERT INTO `users` VALUES ('211005929C8GTNTC', '13900060006', '吃点东西吧', 'Eatalot', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633409027.jpg', 0, '1970-01-01', '中国', '江苏省', '南通市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633409035.jpg', 0, '2021-10-05 12:43:38', '2021-10-05 12:43:38');
INSERT INTO `users` VALUES ('21100593CR144MK4', '13900070007', '爱车一族', 'Lovecar', 'http://39.105.38.113:9000/abc/21100593CR144MK4/1633409282.jpg', 1, '1973-04-04', '中国', '内蒙古自治区', '鄂尔多斯市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/21100593CR144MK4/1633409325.jpg', 0, '2021-10-05 12:47:00', '2021-10-05 12:47:00');
INSERT INTO `users` VALUES ('211005967WASBB9P', '13900080008', '绿色的花', 'Lvhuaa', 'http://39.105.38.113:9000/abc/211005967WASBB9P/1633409866.jpg', 2, '1974-05-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/211005967WASBB9P/1633409828.jpg', 0, '2021-10-05 12:55:29', '2021-10-05 12:55:29');
INSERT INTO `users` VALUES ('21100598TZ9XG6RP', '13900090009', '咩咩羊', 'miemei', 'http://39.105.38.113:9000/abc/21100598TZ9XG6RP/1633410206.jpg', 0, '1976-06-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/21100598TZ9XG6RP/1633410261.jpg', 0, '2021-10-05 13:03:13', '2021-10-05 13:03:13');
COMMIT;

-- ----------------------------
-- Table structure for vlog
-- ----------------------------
DROP TABLE IF EXISTS `vlog`;
CREATE TABLE `vlog` (
  `id` varchar(24) NOT NULL,
  `vloger_id` varchar(24) NOT NULL COMMENT '对应用户表id，vlog视频发布者',
  `url` varchar(255) NOT NULL COMMENT '视频播放地址',
  `cover` varchar(255) NOT NULL COMMENT '视频封面',
  `title` varchar(128) DEFAULT NULL COMMENT '视频标题，可以为空',
  `width` int(6) NOT NULL COMMENT '视频width',
  `height` int(6) NOT NULL COMMENT '视频height',
  `like_counts` int(12) NOT NULL COMMENT '点赞总数',
  `comments_counts` int(12) NOT NULL COMMENT '评论总数',
  `is_private` int(1) NOT NULL COMMENT '是否私密，用户可以设置私密，如此可以不公开给比人看',
  `created_time` datetime NOT NULL COMMENT '创建时间 创建时间',
  `updated_time` datetime NOT NULL COMMENT '更新时间 更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短视频表';

-- ----------------------------
-- Records of vlog
-- ----------------------------
BEGIN;
INSERT INTO `vlog` VALUES ('2109307DX5GFABXP', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/ebab5889-8dd4-4705-b5a9-2e02a4504457.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/ebab5889-8dd4-4705-b5a9-2e02a4504457.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '', 772, 540, 0, 0, 0, '2021-09-30 10:30:13', '2021-09-30 10:30:13');
INSERT INTO `vlog` VALUES ('2109308CKD7ZYNC0', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/684da4e4-6222-4c84-bab6-fca5f22fdd12.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/684da4e4-6222-4c84-bab6-fca5f22fdd12.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '', 960, 540, 0, 0, 1, '2021-09-30 11:50:27', '2021-09-30 11:50:27');
INSERT INTO `vlog` VALUES ('211001BKH355BGHH', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8858a9fc-bd32-4f42-b927-4c78ef2fbf20.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8858a9fc-bd32-4f42-b927-4c78ef2fbf20.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '好多好吃的肉肉呀~~', 360, 640, 0, 0, 0, '2021-10-01 16:17:32', '2021-10-01 16:17:32');
INSERT INTO `vlog` VALUES ('211003HC19CASM3C', '211003H4SG5Y1ZF8', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/4a050c1d-e523-4051-bb75-891b6ac0c1ec.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/4a050c1d-e523-4051-bb75-891b6ac0c1ec.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '空调杀菌啦~~😃😃😃', 360, 640, 0, 0, 0, '2021-10-03 23:01:17', '2021-10-03 23:01:17');
INSERT INTO `vlog` VALUES ('2110048PYTNFGCZC', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8db867e8-568a-4c80-a2bb-d9100842d23e.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8db867e8-568a-4c80-a2bb-d9100842d23e.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第1期 慕课网架构师Redis训练营免费啦~', 540, 960, 0, 0, 0, '2021-10-04 12:15:29', '2021-10-04 12:15:29');
INSERT INTO `vlog` VALUES ('2110048R6R5WW0M8', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/406030dd-a973-4e34-9fbe-557ebfc30065.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/406030dd-a973-4e34-9fbe-557ebfc30065.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第2期 Java架构师Redis训练营学习曲线~', 540, 960, 0, 0, 0, '2021-10-04 12:16:20', '2021-10-04 12:16:20');
INSERT INTO `vlog` VALUES ('2110048RAYSPYG54', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/dc805fc9-fb2c-4c20-91c4-33904877e88e.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/dc805fc9-fb2c-4c20-91c4-33904877e88e.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第3期 程序员学习Redis的必要性', 540, 960, 0, 0, 0, '2021-10-04 12:16:47', '2021-10-04 12:16:47');
INSERT INTO `vlog` VALUES ('2110048RMXYN8KYW', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8ad53fa5-73c3-4587-acd7-55999a590e72.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8ad53fa5-73c3-4587-acd7-55999a590e72.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第4期 学习Redis主从哨兵集群必要性', 540, 960, 0, 0, 0, '2021-10-04 12:17:38', '2021-10-04 12:17:38');
INSERT INTO `vlog` VALUES ('2110048RS1AK5N0H', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/6d3d9817-ffec-4cb2-b977-a9b9aca74bba.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/6d3d9817-ffec-4cb2-b977-a9b9aca74bba.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第5期 Redis慕课网训练营内容~~', 540, 960, 0, 0, 0, '2021-10-04 12:17:58', '2021-10-04 12:17:58');
INSERT INTO `vlog` VALUES ('2110048RXXDD2F5P', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/086ddaf8-7ca0-4fd1-a443-4070c694c714.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/086ddaf8-7ca0-4fd1-a443-4070c694c714.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第6期 2021年7月程序员薪资出炉', 1080, 1920, 0, 0, 0, '2021-10-04 12:18:23', '2021-10-04 12:18:23');
INSERT INTO `vlog` VALUES ('2110048S5RK2BB9P', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/40b49542-1571-4b90-b77b-7bb3a9d7aa71.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/40b49542-1571-4b90-b77b-7bb3a9d7aa71.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第7期 什么是内卷？各行各业的卷中卷', 1080, 1920, 0, 0, 0, '2021-10-04 12:19:14', '2021-10-04 12:19:14');
INSERT INTO `vlog` VALUES ('2110048S95SXG2W0', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/65cf454c-7eb1-45a1-93aa-2388863be80d.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/65cf454c-7eb1-45a1-93aa-2388863be80d.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第8期 高考计算机呦又双叒叕成热门专业', 1080, 1920, 0, 0, 0, '2021-10-04 12:19:36', '2021-10-04 12:19:36');
INSERT INTO `vlog` VALUES ('2110048SBFZ8N25P', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8f372cef-113b-4ddb-991e-61f8f005f4e7.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8f372cef-113b-4ddb-991e-61f8f005f4e7.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第9期 为什么你的云服务器总是被黑被攻击？', 540, 960, 0, 0, 0, '2021-10-04 12:19:51', '2021-10-04 12:19:51');
INSERT INTO `vlog` VALUES ('2110048SF3RC8W4H', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/2bf42f41-06b4-4a55-ba53-b485d404a96b.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/2bf42f41-06b4-4a55-ba53-b485d404a96b.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第10期 程序员要不要做全栈？', 1080, 1920, 0, 0, 0, '2021-10-04 12:20:07', '2021-10-04 12:20:07');
INSERT INTO `vlog` VALUES ('2110048SH1BRRP94', '1001', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/c69b5ffb-78e2-44ec-9b29-f92f74a2bb1a.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/c69b5ffb-78e2-44ec-9b29-f92f74a2bb1a.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '第11期 程序员如何选择鸿蒙OS的开发语言？', 540, 960, 0, 0, 0, '2021-10-04 12:20:20', '2021-10-04 12:20:20');
INSERT INTO `vlog` VALUES ('2110057Z0WAZWBC0', '2110057Y6PN9WMK4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/d0ca7469-7660-49d7-b645-7ece259d1745.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/d0ca7469-7660-49d7-b645-7ece259d1745.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '吃肉肉~~', 640, 360, 0, 0, 0, '2021-10-05 11:09:39', '2021-10-05 11:09:39');
INSERT INTO `vlog` VALUES ('2110057ZG1394940', '2110057Y6PN9WMK4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/3eeb2bcf-2050-4e59-aa38-bcdf3a4e5be2.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/3eeb2bcf-2050-4e59-aa38-bcdf3a4e5be2.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '这是个什么呀？我来瞧一瞧', 262, 466, 0, 0, 0, '2021-10-05 11:11:10', '2021-10-05 11:11:10');
INSERT INTO `vlog` VALUES ('2110058CKB0R4S5P', '2110058BX246X39P', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/678c3cf8-93d9-4452-830b-3e246c5bb12b.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/678c3cf8-93d9-4452-830b-3e246c5bb12b.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '聚个餐~吃肉肉', 640, 360, 0, 0, 0, '2021-10-05 11:50:27', '2021-10-05 11:50:27');
INSERT INTO `vlog` VALUES ('2110058DBZ4RSWZC', '2110058D0KPZSCH0', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/fb03f83b-61d2-4fa3-bce9-ac0b20234216.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/fb03f83b-61d2-4fa3-bce9-ac0b20234216.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '', 640, 360, 0, 0, 0, '2021-10-05 11:52:52', '2021-10-05 11:52:52');
INSERT INTO `vlog` VALUES ('2110058GDGCAZDYW', '2110058FN9GYCFNC', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/0c26702a-c2ec-4a85-9ae4-4095f142b01f.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/0c26702a-c2ec-4a85-9ae4-4095f142b01f.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '杰森斯坦森真特么帅~😊', 640, 360, 0, 0, 0, '2021-10-05 11:59:03', '2021-10-05 11:59:03');
INSERT INTO `vlog` VALUES ('211005931KAH325P', '211005929C8GTNTC', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/55d8fb3d-c0cf-4533-804e-0e5658c1bf04.mp4', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633408583-compressed-IMG_0020.PNG', '看着挺好吃', 622, 830, 0, 0, 0, '2021-10-05 12:45:48', '2021-10-05 12:45:48');
INSERT INTO `vlog` VALUES ('2110059373F4ADWH', '211005929C8GTNTC', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/2e9c2ce0-ec24-4e06-bee5-3ecf24808815.mp4', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633408909-compressed-IMG_0024.PNG', '爱吃醋', 830, 622, 0, 0, 0, '2021-10-05 12:46:24', '2021-10-05 12:46:24');
INSERT INTO `vlog` VALUES ('21100594K819846W', '21100593CR144MK4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/c62d2cf3-0d83-45b8-bc36-63afba28c981.mp4', 'http://39.105.38.113:9000/abc/21100593CR144MK4/1633408904-compressed-IMG_0025.PNG', '哈哈哈我们都是爱吃的死胖子🤓', 540, 960, 0, 0, 0, '2021-10-05 12:50:29', '2021-10-05 12:50:29');
INSERT INTO `vlog` VALUES ('211005956F0BN7R4', '21100593CR144MK4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/4309dd6a-cfa4-410a-a0c4-d205ef95f83c.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/4309dd6a-cfa4-410a-a0c4-d205ef95f83c.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '这个视频是没有声音的哦！！！😜😜😜', 540, 960, 0, 0, 0, '2021-10-05 12:52:20', '2021-10-05 12:52:20');
INSERT INTO `vlog` VALUES ('21100597F3ABW0ZC', '211005967WASBB9P', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8e7a63a7-cfc5-4cfb-b559-411232ca6e07.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/8e7a63a7-cfc5-4cfb-b559-411232ca6e07.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '这个视频好像也没声音的，哈哈哈🤩🤩🤩', 540, 960, 0, 0, 0, '2021-10-05 12:59:09', '2021-10-05 12:59:09');
INSERT INTO `vlog` VALUES ('21100597NPC09FCH', '211005967WASBB9P', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/146530e6-764c-4db2-b624-8042031ed4f7.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/146530e6-764c-4db2-b624-8042031ed4f7.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '生日蛋糕不错吧', 830, 622, 0, 0, 0, '2021-10-05 12:59:45', '2021-10-05 12:59:45');
INSERT INTO `vlog` VALUES ('21100599C6HCGXAW', '21100598TZ9XG6RP', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/bc845535-c531-49a4-9413-9ae4d4be27c3.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/bc845535-c531-49a4-9413-9ae4d4be27c3.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '真的好漂亮啊，想来一次想走就走的旅行！！🥴🥴🥴', 540, 960, 0, 0, 0, '2021-10-05 13:04:57', '2021-10-05 13:04:57');
INSERT INTO `vlog` VALUES ('21100599X82DARAW', '21100598TZ9XG6RP', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/1c020c9e-df45-4485-9ece-2e50d88fb9d0.mp4', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a510f11a-afcf-48f9-bcff-848ce1501f2f/1c020c9e-df45-4485-9ece-2e50d88fb9d0.mp4?x-oss-process=video/snapshot,t_1,f_jpg,ar_auto', '听说再发一次一定会火，哈哈哈', 774, 540, 0, 0, 0, '2021-10-05 13:06:21', '2021-10-05 13:06:21');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
